Release 10.1A: OpenEdge Data Management:
SQL Reference

EXEC SQL Delimiter

In C language programs, you must precede embedded SQL statements with the EXEC SQL delimiter so that the precompiler can distinguish statements from the host language statements.

Note: Constructs within a BEGIN-END DECLARE SECTION do not require the EXEC SQL delimiter.

Syntax

EXEC SQL sql_statement ;

sql_statement

An SQL statement to be processed by the ESQL precompiler. You must terminate each SQL statement with a semicolon to mark the end of the statement.

Example

EXEC SQL WHENEVER SQLERROR GOTO selerr ; EXEC SQL PREPARE stmtid from :sel_stmt_v ; EXEC SQL DECLARE dyncur CURSOR FOR stmtid ; EXEC SQL OPEN dyncur ; EXEC SQL WHENEVER NOT FOUND GOTO seldone ;

Note

In general, the ESQL precompiler does not parse host language statements and therefore does not detect any syntax or semantic errors in host language statements. The exceptions to this rule are:
Recognition of host language blocks. The precompiler recognizes host language blocks in order to determine the scope of variables and types.
Constants defined with the #define preprocessor command. To evaluate these constants, the ESQL precompiler invokes the C language preprocessor before beginning embedded SQL processing.

Authorization

None